AX_GL Data Dictionary

General Ledger Transaction Details

Original Column Name Expanded Column Name Description
GLID General Ledger ID The unique identifier for a General Ledger entry.
Amt Amount The monetary value associated with the transaction.
Balance Balance The current balance after the transaction has been recorded.
CAID Current Account ID Identifier of the current account affected by the transaction.
CAEntID Current Account Entry Details Details pertaining to the entry in the current account associated with the transaction.
CAGrpID Current Account Group Details Group classification details of the current account.
DeptID Department Details Identifying information about the department responsible for or involved in the transaction.
DescX Description X A description or narrative explaining the nature of the item or entry.
DtPost Date Posted The date on which the transaction was recorded in the General Ledger.
DtTrans Date Transacted The date the transaction took place or was initiated.
GLID_Ref General Ledger ID Reference Reference to a General Ledger ID that is related to this transaction for cross-referencing purposes.
GLPeriodID General Ledger Period Details Details regarding the fiscal period of the General Ledger entry.
GLTypeID General Ledger Type Details Categorization details of the General Ledger entry based on the type of transaction.
IsReverseTrans Is Reverse Transaction Indicates whether the transaction reverses a previously posted transaction.
IsVoided Is Voided Indicates if the transaction has been voided and should not be considered in current financial calculations.
ItemPOID Item Purchase Order ID Identifier of the purchase order for the item involved in the transaction.
PayMethodID Payment Method Details Details about the method of payment used for the transaction.
RecptID Recipient Details Information about the recipient of goods or services related to the transaction.
RecptTypeID Recipient Type Details Classification of the recipient as per the predefined recipient types.
RefText Reference Text Textual reference information that provides additional context for the transaction.
SiteID Site Details Information specifying the location or site where the transaction is relevant or was recorded.
SourceID Source Details Details about the origin of the transaction, such as the initiating department or external entity.
SourceTypeID Source Type Details Classification information about the source of the transaction.
TransTypeID Transaction Type Details Information describing the nature of the transaction, categorized by predefined transaction types.
ZUChkSum ZU Check Sum An audit trail checksum value used for data integrity verification in transaction logs.
ZUDate ZU Date The date associated with the audit log entry used for tracking changes and updates.
ZULogonHisID ZU Logon History Details Details related to a user's logon session that is captured as part of the system's security and audit logs.